// 期初现金银行
const {DataTypes, db } = require("../db");
db.define('initAccount', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,comment:'租户ID'}, 
accId:{type: DataTypes.INTEGER,comment:'账户ID'}, 
amount:{type: DataTypes.DECIMAL(20, 2),comment:'期初金额'}, 
createdAt:{type: DataTypes.STRING(20),comment:''}, 
updatedAt:{type: DataTypes.STRING(20),comment:''}, 
ctime:{type: DataTypes.STRING(20),comment:''}, 
cby:{type: DataTypes.INTEGER,comment:''}, 
uby:{type: DataTypes.INTEGER,comment:''}, 
utime:{type: DataTypes.STRING(20),comment:''}, 
isDel:{type: DataTypes.INTEGER,comment:''}, 

}, {
    tableName: 'init_account',
    timestamps: false,
    comment: '期初现金银行',
    indexes: [
        {name:'已存在相同账户', unique: true, fields:['tenantId', 'accId']}
    ]
});